{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Meal Planner"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Meal Planner","index":0,"n_rows":29,"n_cols":15,"rows_kept":29,"merged":[[0,0,0,15],[1,1,1,14],[2,4,2,14],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12],[3,13,3,14],[4,1,4,2],[4,3,4,4],[4,5,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[6,1,6,2],[6,3,6,4],[6,5,6,6],[6,7,6,8],[6,9,6,10],[6,11,6,12],[6,13,6,14],[10,1,10,2],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,11,10,12],[10,13,10,14],[14,1,14,2],[14,3,14,4],[14,5,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[14,13,14,14],[18,1,18,2],[18,3,18,4],[18,5,18,6],[18,7,18,8],[18,9,18,10],[18,11,18,12],[18,13,18,14],[28,1,31,14]]}
["Meal Planner"]
[null,"Type the week's starting date in cell E3.  The rest of the dates will be filled in for you."]
[{"$nulls":3},"Meal plan for the week beginning:","2000-08-06"]
[null,{"$f":"E3","v":"2000-08-06"},null,{"$f":"IF(B4<>\"\",B4+1,\"\")","v":"2000-08-07"},null,{"$f":"IF(D4<>\"\",D4+1,\"\")","v":"2000-08-08"},null,{"$f":"IF(F4<>\"\",F4+1,\"\")","v":"2000-08-09"},null,{"$f":"IF(H4<>\"\",H4+1,\"\")","v":"2000-08-10"},null,{"$f":"IF(J4<>\"\",J4+1,\"\")","v":"2000-08-11"},null,{"$f":"IF(L4<>\"\",L4+1,\"\")","v":"2000-08-12"}]
[null,{"$f":"E3","v":"2000-08-06"},null,{"$f":"IF(B5<>\"\",B5+1,\"\")","v":"2000-08-07"},null,{"$f":"IF(B5<>\"\",B5+2,\"\")","v":"2000-08-08"},null,{"$f":"IF(B5<>\"\",B5+3,\"\")","v":"2000-08-09"},null,{"$f":"IF(B5<>\"\",B5+4,\"\")","v":"2000-08-10"},null,{"$f":"IF(B5<>\"\",B5+5,\"\")","v":"2000-08-11"},null,{"$f":"IF(B5<>\"\",B5+6,\"\")","v":"2000-08-12"}]
[null,"Breakfast",null,"Breakfast",null,"Breakfast",null,"Breakfast",null,"Breakfast",null,"Breakfast",null,"Breakfast"]
[]
[null,"Calories:",null,"Calories:",null,"Calories:",null,"Calories:",null,"Calories:",null,"Calories:",null,"Calories:"]
[null,"Fat grams:",null,"Fat grams:",null,"Fat grams:",null,"Fat grams:",null,"Fat grams:",null,"Fat grams:",null,"Fat grams:"]
[null,"Lunch",null,"Lunch",null,"Lunch",null,"Lunch",null,"Lunch",null,"Lunch",null,"Lunch"]
[]
[null,"Calories:",null,"Calories:",null,"Calories:",null,"Calories:",null,"Calories:",null,"Calories:",null,"Calories:"]
[null,"Fat grams:",null,"Fat grams:",null,"Fat grams:",null,"Fat grams:",null,"Fat grams:",null,"Fat grams:",null,"Fat grams:"]
[null,"Dinner",null,"Dinner",null,"Dinner",null,"Dinner",null,"Dinner",null,"Dinner",null,"Dinner"]
[]
[null,"Calories:",null,"Calories:",null,"Calories:",null,"Calories:",null,"Calories:",null,"Calories:",null,"Calories:"]
[null,"Fat grams:",null,"Fat grams:",null,"Fat grams:",null,"Fat grams:",null,"Fat grams:",null,"Fat grams:",null,"Fat grams:"]
[null,"Snack",null,"Snack",null,"Snack",null,"Snack",null,"Snack",null,"Snack",null,"Snack"]
[]
[null,"Calories:",null,"Calories:",null,"Calories:",null,"Calories:",null,"Calories:",null,"Calories:",null,"Calories:"]
[null,"Fat grams:",null,"Fat grams:",null,"Fat grams:",null,"Fat grams:",null,"Fat grams:",null,"Fat grams:",null,"Fat grams:"]
[null,"Calories:",{"$f":"C8+C12+C16+C20","v":0},"Calories:",{"$f":"E8+E12+E16+E20","v":0},"Calories:",{"$f":"G8+G12+G16+G20","v":0},"Calories:",{"$f":"I8+I12+I16+I20","v":0},"Calories:",{"$f":"K8+K12+K16+K20","v":0},"Calories:",{"$f":"M8+M12+M16+M20","v":0},"Calories:",{"$f":"O8+O12+O16+O20","v":0}]
[null,"Fat grams:",{"$f":"C9+C13+C17+C21","v":0},"Fat grams:",{"$f":"E9+E13+E17+E21","v":0},"Fat grams:",{"$f":"G9+G13+G17+G21","v":0},"Fat grams:",{"$f":"I9+I13+I17+I21","v":0},"Fat grams:",{"$f":"K9+K13+K17+K21","v":0},"Fat grams:",{"$f":"M9+M13+M17+M21","v":0},"Fat grams:",{"$f":"O9+O13+O17+O21","v":0}]
[null,"% calories from fat:",{"$f":"IF(C22,C23*9/C22,0)","v":{"v":0,"d":"0%"}},"% calories from fat:",{"$f":"IF(E22,E23*9/E22,0)","v":{"v":0,"d":"0%"}},"% calories from fat:",{"$f":"IF(G22,G23*9/G22,0)","v":{"v":0,"d":"0%"}},"% calories from fat:",{"$f":"IF(I22,I23*9/I22,0)","v":{"v":0,"d":"0%"}},"% calories from fat:",{"$f":"IF(K22,K23*9/K22,0)","v":{"v":0,"d":"0%"}},"% calories from fat:",{"$f":"IF(M22,M23*9/M22,0)","v":{"v":0,"d":"0%"}},"% calories from fat:",{"$f":"IF(O22,O23*9/O22,0)","v":{"v":0,"d":"0%"}}]
[{"$nulls":9},"Weekly total ",null,"Calories:",null,null,{"$f":"C22+E22+G22+I22+K22+M22+O22","v":0}]
[{"$nulls":11},"Fat grams:",null,null,{"$f":"C23+E23+G23+I23+K23+M23+O23","v":0}]
[{"$nulls":11},"% calories from fat:",null,null,{"$f":"IF(O25,O26*9/O25,0)","v":{"v":0,"d":"0.0%"}}]
[]
[null,"This worksheet can be used to plan meals. Enter meal information in the white boxes. Excel will calculate the results in the yellow boxes.\n\nThis worksheet is locked to preserve the formulas that calculate your results. To unlock the worksheet, go to the Tools menu, select Protection, then choose Unprotect Sheet. This sheet does not use a password."]